Evaluate(Object[]) Method

In This Topic

Counts the number of cells within a range that meet the given criteria.

Syntax

'Declaration
 
Public Overloads Overrides Function Evaluate( _
   ByVal args() As Object _
) As Object

'Usage
 
Dim instance As CalcCountIfFunction
Dim args() As Object
Dim value As Object
 
value = instance.Evaluate(args)

public override object Evaluate( 
   object[] args
)

args

The args contains 2 items: range, criteria.

Range is one or more cells to count, including numbers or names, arrays, or references that contain numbers. Blank and text values are ignored.

Criteria is the criteria in the form of a number, expression, cell reference, or text that defines which cells will be counted.

A System.Object value that indicates the evaluate result.